UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p8C2pRW3Itgc+ieeebTLVd9COGLyDU4QhHz8JIJ/5Pg='
WHERE
key_id = 'fc8e5b2f766caadc1581d38b93d11e24a41dc2a98abd58e5f88418cfe7d0cdf2'
AND (
token = 'p8C2pRW3Itgc+ieeebTLVd9COGLyDU4QhHz8JIJ/5Pg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)