UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vPVyRg3ZlKrekO4TcOnj8DrCTBUmiWpEvYORlrjMhws='
WHERE
key_id = 'be414df28a01ee6357d8cfc5c47ca0f33da08ce959573cb15013df37d49d7198'
AND (
token = 'vPVyRg3ZlKrekO4TcOnj8DrCTBUmiWpEvYORlrjMhws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)