UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jvuiT6beHnlypW4JxG8980yfIboH7r1FIIoE+DXzbK0='
WHERE
key_id = 'b1fd3781568aa36e857b39f11a5770ab15cc8f8a479d2a7bdbb221b3643f8a19'
AND (
token = 'jvuiT6beHnlypW4JxG8980yfIboH7r1FIIoE+DXzbK0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)