UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9THPz4pTjJEzu709FLV9TVEDrCGEuD+5cny+Ouf6RUc='
WHERE
key_id = '57769081d86b27b1c0c933ed614e876a1c9ab30f1556e872b5bfa0a59296c060'
AND (
token = '9THPz4pTjJEzu709FLV9TVEDrCGEuD+5cny+Ouf6RUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)