UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M1xfTSidjz4EgXVRkxfSM4scuddA9F/IIiISzCjpURM='
WHERE
key_id = '290c75b3f137c14dc565e20fb6fc9fc2a711ebb23e898cf84d50dd00ed7264a1'
AND (
token = 'M1xfTSidjz4EgXVRkxfSM4scuddA9F/IIiISzCjpURM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)