UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iC5AXcEF5Xl6UQiUAg6vXGCmzATfrCmxTWYwtL2apHE='
WHERE
key_id = '54ab9c96c13daeb0208cd7ecc127a8499872f071a0e05ef8b8ef933854a996df'
AND (
token = 'iC5AXcEF5Xl6UQiUAg6vXGCmzATfrCmxTWYwtL2apHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)