UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/0D/FKI3Hxn50bIPoDXA08ApWofGZyErTr6nYcWV9Jg='
WHERE
key_id = '4cb1d40963bec5ba72b8203ec6a48f344b78c16eba4d0841be8b2f097ea98ca3'
AND (
token = '/0D/FKI3Hxn50bIPoDXA08ApWofGZyErTr6nYcWV9Jg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)