UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZlJ5TicWcnwMAyEf8zmKre5PekQMR9UU5Jg7rrtqviA='
WHERE
key_id = 'c770f4bf47aa437e9e1d4bccb434bacd9138f61011a6023561e5e20e306e1701'
AND (
token = 'ZlJ5TicWcnwMAyEf8zmKre5PekQMR9UU5Jg7rrtqviA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)