UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TCtWHQXlHBI98whk7vmuXXfHEdA9BCJ7mTKrUMscTdA='
WHERE
key_id = '4a0b8cba2d65f6fe6714a5a3a6c8bbeeecec627ebc617e53a46ce5ff30f6cb9c'
AND (
token = 'TCtWHQXlHBI98whk7vmuXXfHEdA9BCJ7mTKrUMscTdA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)