UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hZ/dfsXHJ2vHgM1w2mKpbMFvzodfZgVhU+WIRioxJmY='
WHERE
key_id = '02e9328c1cc7c4639268e0c0500cf7b23541446d05b93d51459079c51815ffa9'
AND (
token = 'hZ/dfsXHJ2vHgM1w2mKpbMFvzodfZgVhU+WIRioxJmY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)