UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z9JECFE7U6CUAvyaksJMw6py9BO+cLohUtlDw87O+c0='
WHERE
key_id = '317a772018bd73ca3b3e0d2d601d85ee1b365e82f094c1e71db2a988b2134b26'
AND (
token = 'z9JECFE7U6CUAvyaksJMw6py9BO+cLohUtlDw87O+c0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)