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