UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vrMBdLUMdzGm2X+nWLjjItmg1vsZ5lTZ7f6B2Yo25Pw='
WHERE
key_id = 'be4697d820f214a1a60ca740665238f0dee1fefff3435482d9c32cdf5bdfa3c2'
AND (
token = 'vrMBdLUMdzGm2X+nWLjjItmg1vsZ5lTZ7f6B2Yo25Pw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)