UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3gRzbD7Uycz4JuA1k5OLhdshQfpKjj7JXJksMEI1po4='
WHERE
key_id = '0b9b93486b2cb2265847ddcb64fe7a37f546cc6ecb4ebf1d4da9257e66d45874'
AND (
token = '3gRzbD7Uycz4JuA1k5OLhdshQfpKjj7JXJksMEI1po4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)