UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6l8texIGOCPpBe1MGg9tUH03RuiPqnMuRKcxhwerQUs='
WHERE
key_id = '96e9f1e16a65d10f0b235284d6855bad99ae3d5cb3e583901209d9edbcd992de'
AND (
token = '6l8texIGOCPpBe1MGg9tUH03RuiPqnMuRKcxhwerQUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)