UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0pT5807qLyrCVQGzfUnKO6IX+1Ae5ZHaDx8z9Mxhbxw='
WHERE
key_id = 'dcf472aa8fb1a5f8028d5e45c64d8d2e7818a96d9fe71f56adaf4de44d232df6'
AND (
token = '0pT5807qLyrCVQGzfUnKO6IX+1Ae5ZHaDx8z9Mxhbxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)