UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9x1SS4C8dCYnl+Z0JH1VK/27pTB0QXWbzZTCi90A6I0='
WHERE
key_id = 'c1cbc31c21849d01956ac5e0623e39abcf37957238c13096427e325d81db332b'
AND (
token = '9x1SS4C8dCYnl+Z0JH1VK/27pTB0QXWbzZTCi90A6I0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)