UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qGjZXbRGF7NCL81vnufd69utZiURkJImQdU8wwwuXYc='
WHERE
key_id = '80da71c1df330ac8f9997f0d7a34d575612c79fe5f693a4bea5e8226045db04c'
AND (
token = 'qGjZXbRGF7NCL81vnufd69utZiURkJImQdU8wwwuXYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)