UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oHaYqFy9J7AQLOgmJkTFhLuc2Vevf2xI0Kwu2lX7oNc='
WHERE
key_id = '5d2d6b03c4638d1ab38ad2d96a315a9c2b3489c8de4a35cc7df9cf1014b2c10e'
AND (
token = 'oHaYqFy9J7AQLOgmJkTFhLuc2Vevf2xI0Kwu2lX7oNc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)