UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7PuxS5yHRWvQw19/t6bkKg/DCAgVFRRcACJrQ/3HMW0='
WHERE
key_id = '9c4387872a92229a2a3d57b4e241d84a7231f8f22352c9147532710e0a103a5a'
AND (
token = '7PuxS5yHRWvQw19/t6bkKg/DCAgVFRRcACJrQ/3HMW0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)