UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '67ZV5zvnvpwfx2RwK/1PKjvXxuxHre4GYDszBY9G8p0='
WHERE
key_id = 'c2d5888cd42f9984842da3361e74c2daf14c4d7192e1d59a93362f979d2a5082'
AND (
token = '67ZV5zvnvpwfx2RwK/1PKjvXxuxHre4GYDszBY9G8p0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)