UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T6sMyPVLbr/P6+H5J+AQVTolYi207nwrjBU4v+f7Qgg='
WHERE
key_id = 'da3d40a64fd3892aa690f67a54fde253d114291ee6c3a359a289687016c9477f'
AND (
token = 'T6sMyPVLbr/P6+H5J+AQVTolYi207nwrjBU4v+f7Qgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)