UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6qBSxb8KUukR25ywypsdgfMRavC3YLInu/pMH62EsH8='
WHERE
key_id = '81ce5a1fa358772253608b3a494e42807675cb24efc81a18b5ac615684d3952f'
AND (
token = '6qBSxb8KUukR25ywypsdgfMRavC3YLInu/pMH62EsH8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)