UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hrdNh6pSgKFZr4LRUVIhSxFmBPnLnwHUODOD2sNJjOc='
WHERE
key_id = '4ba8113daea12b7703feac40b7e126acb4a17611870b7f0012868ad0827d5df5'
AND (
token = 'hrdNh6pSgKFZr4LRUVIhSxFmBPnLnwHUODOD2sNJjOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)