UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W29iATsgHov7loI5mfU4YAVSks3McP0qXqEnX9jjs+4='
WHERE
key_id = '9766d7c375d251b798ca8339e02a06cdb1371f99f3a71192bbba431cc5e7b0ea'
AND (
token = 'W29iATsgHov7loI5mfU4YAVSks3McP0qXqEnX9jjs+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)