UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RSfuHR1G6TlUPeaK+jaQSPLjH/vQiwBoXtKCoz+iqPM='
WHERE
key_id = 'e257ec99793cd727e0855a7857797e3469cbf7e4ae7c8f9216059376db68787a'
AND (
token = 'RSfuHR1G6TlUPeaK+jaQSPLjH/vQiwBoXtKCoz+iqPM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)