UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h1wUDTUzY3OZBpHqYnmjU7JkK4g18Ccd31it+zsRhCA='
WHERE
key_id = 'b5564414918c729ee63f44f1283142bd17d55a9920d52e03bde016b1d8c0e34e'
AND (
token = 'h1wUDTUzY3OZBpHqYnmjU7JkK4g18Ccd31it+zsRhCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)