UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5sQdWonXQzEN6osFcSWUtXT7RRDkvguwW5PZCwtA3Cs='
WHERE
key_id = '2b9c6ee3ea1205fd7f2db550f48038526ebbea6230f0b0751649c68e3dc242dd'
AND (
token = '5sQdWonXQzEN6osFcSWUtXT7RRDkvguwW5PZCwtA3Cs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)