UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AfRX2GmX3WhCl6x461RY5Bv6B6vV28keTUJ3Nm3L9uY='
WHERE
key_id = '0ca0427eae45a279f9fdd007642750ee87baf483327805c9f0299680d8ea9ad4'
AND (
token = 'AfRX2GmX3WhCl6x461RY5Bv6B6vV28keTUJ3Nm3L9uY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)