UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1hZ8hR6aa0tUWm7iLJSiHVE7/SPed5JZ1cmoo5X2MxA='
WHERE
key_id = '8a5cfb776a9430f85f89adc51a935fed985f2b37b072af7c2589d259d76ee262'
AND (
token = '1hZ8hR6aa0tUWm7iLJSiHVE7/SPed5JZ1cmoo5X2MxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)