UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hzZd1z3vPcOs41/V3OBzYFpKBvXHxi/ZnZtmhuCynM0='
WHERE
key_id = '6254d414d9d5890e90c017e9f39715bfd29098cb83d69756cdc3ba9af6e14a1e'
AND (
token = 'hzZd1z3vPcOs41/V3OBzYFpKBvXHxi/ZnZtmhuCynM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)