UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3SXSOHL1rN4b5oFKYi7GXQm1t1aTH1TiX76phTLqwvs='
WHERE
key_id = '47f9ff73d697d0f48d5a276e62c1b012f082f92ec44c6eaa951066d2438f5104'
AND (
token = '3SXSOHL1rN4b5oFKYi7GXQm1t1aTH1TiX76phTLqwvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)