UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '32MdIoP4NTPq9ZTI3XruCrJkdO3AbU6k8R6cBC4lytA='
WHERE
key_id = 'ee04d6585a565f99a0af1d177b7877a7b809f91adab9998cc1026500e5a7868d'
AND (
token = '32MdIoP4NTPq9ZTI3XruCrJkdO3AbU6k8R6cBC4lytA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)