UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xW7G3QxL0Z87by+4djx34Z8s92pzfIZfdLX7Bu5KAnE='
WHERE
key_id = 'b710f4eee245bd0ce4a35326824c62afcbd1dd9c6743547a1d174b2646e7833f'
AND (
token = 'xW7G3QxL0Z87by+4djx34Z8s92pzfIZfdLX7Bu5KAnE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)