UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ph/9sNHAnwlb48fg2Um7RaEtIbLwWKLJKDGmFEw0pRM='
WHERE
key_id = 'a4254a24b01f5fff0a4819c034c077033eb89afd9f3cd02f5d7a91abd785f336'
AND (
token = 'Ph/9sNHAnwlb48fg2Um7RaEtIbLwWKLJKDGmFEw0pRM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)