UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QNhKBs6tx9wk6qqXsR7eYTHZACY+zwn1Hghigwjje28='
WHERE
key_id = '3faa346e513cc5adfaf7bd6ebbc2440a6e8329ac206d5f31fa39148bc2fbf897'
AND (
token = 'QNhKBs6tx9wk6qqXsR7eYTHZACY+zwn1Hghigwjje28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)